From c158dc45972afce391ea67263794ae9e97bdd495 Mon Sep 17 00:00:00 2001 From: Siebrand Mazeland Date: Sun, 17 May 2009 20:39:11 +0000 Subject: [PATCH] * replace hard coded namespace numbers by the php define * remove leading spaces, and replace leading space blocks by tabs Inspired by a patch by jidanni in bug 18273. --- includes/specials/SpecialWantedpages.php | 26 ++++++++++++------------ 1 file changed, 13 insertions(+), 13 deletions(-) diff --git a/includes/specials/SpecialWantedpages.php b/includes/specials/SpecialWantedpages.php index b7e82cf28c..eeca87ab01 100644 --- a/includes/specials/SpecialWantedpages.php +++ b/includes/specials/SpecialWantedpages.php @@ -27,19 +27,19 @@ class WantedPagesPage extends WantedQueryPage { $pagelinks = $dbr->tableName( 'pagelinks' ); $page = $dbr->tableName( 'page' ); $sql = "SELECT 'Wantedpages' AS type, - pl_namespace AS namespace, - pl_title AS title, - COUNT(*) AS value - FROM $pagelinks - LEFT JOIN $page AS pg1 - ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title - LEFT JOIN $page AS pg2 - ON pl_from = pg2.page_id - WHERE pg1.page_namespace IS NULL - AND pl_namespace NOT IN ( 2, 3 ) - AND pg2.page_namespace != 8 - GROUP BY pl_namespace, pl_title - HAVING COUNT(*) > $count"; + pl_namespace AS namespace, + pl_title AS title, + COUNT(*) AS value + FROM $pagelinks + LEFT JOIN $page AS pg1 + ON pl_namespace = pg1.page_namespace AND pl_title = pg1.page_title + LEFT JOIN $page AS pg2 + ON pl_from = pg2.page_id + WHERE pg1.page_namespace IS NULL + AND pl_namespace NOT IN ( " . NS_USER . ", ". NS_USER_TALK . ") + AND pg2.page_namespace != " . NS_MEDIAWIKI . " + GROUP BY pl_namespace, pl_title + HAVING COUNT(*) > $count"; wfRunHooks( 'WantedPages::getSQL', array( &$this, &$sql ) ); return $sql; -- 2.20.1